insert overwrite table jms_dwd.dwd_tab_barscan_scan_delete_base_dt partition(dt)
select
    billcode
    ,packagecode
    ,scan_type
    ,scan_time
    ,input_time
    ,upload_time
    ,delete_time
    ,delete_site_id
    ,delete_site_code
    ,delete_site_name
    ,delete_user_code
    ,delete_user_name
    ,scan_site_id
    ,scan_site_code
    ,scan_site_name
    ,scan_user_code
    ,scan_user_name
    ,device_id
    ,source
    ,remark
    ,create_time
    ,dt
from jms_ods.tab_barscan_scan_delete
where dt = '{{ execution_date | cst_ds }}';